{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FilingGuide","Cover Pages 1-2","Cover Page 3","Report Pages 1-6","SurchargeInformation","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FilingGuide","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cover Pages 1-2","index":1,"n_rows":68,"n_cols":10,"rows_kept":68,"cut":false,"hidden":false,"merged":[[13,1,13,2],[13,4,13,5],[16,1,16,2],[16,4,16,8],[4,1,4,2],[4,4,4,5],[6,0,6,8],[8,1,8,7],[10,1,10,2],[10,4,10,8],[47,1,47,9],[51,1,51,9],[53,1,53,9],[55,1,55,9],[18,1,18,2],[18,4,18,6],[20,0,20,9],[49,1,49,9],[67,1,68,9],[11,4,11,8],[57,1,57,7],[59,1,59,9],[61,1,61,9],[63,1,63,9],[65,1,65,9],[23,0,23,8],[26,0,26,8],[28,0,28,8],[30,5,30,6],[33,0,33,8],[38,0,38,9],[39,5,39,6],[43,0,43,9],[45,1,45,7]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"NARUC Class C"]
[null,null,null,null,null,null,null,null,null,"Privately Owned"]
[null,"Docket No.:",null,null,"22-01003"]
[]
["ANNUAL REPORT"]
[]
[null,"OF"]
[]
[null,"Company Name:"]
[null,null,null,null,"(Legal Name of Utility)"]
[]
[null,"CPC Number(s):"]
[]
[]
[null,"Principal Office Address:"]
[]
[null,"For the Period Ending:",null,null,"   December 31,",null,null,2021]
[]
["WASTEWATER UTILITY"]
[]
[]
["TO THE"]
[]
[]
["PUBLIC UTILITIES COMMISSION"]
[]
["OF NEVADA"]
[]
[null,null,null,null,"Date of filing:"]
[]
[]
["Due by May 15, 2022"]
[]
[null,null,null,null,"Check one:"]
[null,null,null,null,null,"Original Submission"]
[null,null,null,null,null,"Corrected Submission*"]
["* If the original filing is being amended or corrected, the entire report must be resubmitted."]
[null,null,null,null,"Corrected Filing Date:"]
[]
[]
[]
["GENERAL GUIDELINES FOR REPORTING"]
[]
["1.","This form is formatted using Microsoft Excel to allow for electronic preparation.   "]
[]
[2,"In the data areas on the following pages, please input the requested information in the gray highlighted areas.  The spreadsheet has been programmed to perform all the necessary calculations.  Non-highlighted areas are locked and cannot be accessed by the user."]
[]
[3,"Enter whole dollar amounts only.  Round cents up or down to the nearest whole dollar."]
[]
[4,"If the amount to be input into a normally positive data field is negative, then precede the amount with a negative sign (-)."]
[]
[5,"If the amount to be input is zero, then input a zero; Excel will display a hyphen in the cell.  Do not input \na hyphen."]
[]
[6,"The annual report should be fully completed.  References to returns of former years or to other reports should not take the place of required entries except as specifically instructed by the PUCN."]
[]
[7,"Where information called for is not provided, explain the reason for its omission. "]
[]
[8,"If it is necessary or desirable to show additional statements or schedules for the purpose of further explanation, they should be made on standard letter-size paper.  Each additional supporting schedule should contain the page and line reference to the PUCN form so that PUCN staff will be able to follow the preparer's intentions."]
[]
[9,"Wherever schedules call for comparisons to figures of a previous year, the figures reported must be based upon those shown on this company's annual report from the previous year or an appropriate explanation given as to why different figures were used."]
[null,"      "]
[10,"The Nevada Administrative Code 704.628(6) requires that the books and records maintained by the utility must comply with the systems of accounts established for water/wastewater utilities prepared by the National Association of Regulatory Commissioners (NARUC).  The account numbers listed in the accompanying annual report are NARUC account numbers.  If the company uses a different account numbering system, please attach an explanation along with a cross-reference from the company's account numbers to the NARUC account numbers."]
[null,"      "]
[11,"If the utility collects and maintains a Commission-approved surcharge to fund system improvements, complete the supplemental surcharge information schedules located at the end of this report.  Remember to include a copy of the year-end bank statement for the surcharge account as requested on the form."]
[]
[12,"When printing this form, print each tab separately for correct pagination.  Do NOT print the entire workbook."]

{"sheet":"Cover Page 3","index":2,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[47,0,47,12],[36,2,36,8],[37,2,37,8],[39,1,39,11],[40,1,43,11],[0,0,0,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[10,2,10,10],[8,2,8,10],[11,2,11,6],[13,4,13,6],[15,7,15,8],[18,2,18,8],[23,3,23,8],[19,4,19,8],[24,3,24,8],[25,3,25,8],[35,2,35,8],[23,10,23,11],[24,10,24,11],[26,3,26,8],[28,7,28,11],[30,1,30,11],[25,10,25,11],[26,10,26,11],[32,2,32,8],[31,2,31,8],[33,2,33,8],[34,2,34,8]]}
["PUBLIC UTILITIES COMMISSION OF NEVADA"]
[]
["WASTEWATER UTILITY ANNUAL REPORT"]
["Class C"]
["(Annual Revenues of less than $200,000)"]
[]
[1,{"$f":"CONCATENATE(\"For the Period Ending:          December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:          December 31, 2021"},null,null,null,null,null,null,null,null,null,null,null,2006]
[]
[2,{"$f":"CONCATENATE(\"Report of:   \",'Cover Pages 1-2'!E11)","v":"Report of:   "}]
[]
[3,"Address:"]
[null,"     City:  ",null,null,null,null,null,null,"State:",null,"Zip Code:"]
[]
[4,"Telephone number:"]
[]
[5,"Date of original organization of utility:"]
[]
[6,"Person to whom correspondence should be addressed concerning this report:"]
[null,"      Name:"]
[null,"      Telephone No.:"]
[]
[]
[7,"Utility officers:"]
[null,"      President:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Vice-Pres:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Treasurer:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Secretary:",null,null,null,null,null,null,null,"Telephone No."]
[]
[8,"What public services are rendered?"]
[]
[9,"If a corporation - Provide the Name and Percentage of each person owning or holding directly or indirectly five (5) percent or more of the voting securities of this company:"]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[]
[10,"Give a brief description of major transactions which have occurred during the year which will have material effect on operations, such as rate changes, or changes in plant or operating practices.  Provide any additional information or other explanations that are needed in order for the reader to understand what is in the report, attaching additional pages if necessary:"]

{"sheet":"Report Pages 1-6","index":3,"n_rows":347,"n_cols":8,"rows_kept":347,"cut":false,"hidden":false,"merged":[[290,4,290,6],[290,0,290,1],[346,0,346,1],[235,1,235,5],[235,0,236,0],[260,0,260,5],[298,2,298,4],[300,1,300,4],[295,0,295,7],[299,2,299,4],[301,1,301,4],[308,1,308,5],[309,1,309,5],[321,3,321,7],[303,1,303,7],[316,1,316,5],[319,3,319,7],[351,1,351,2],[323,3,323,7],[324,3,324,7],[325,3,325,7],[328,3,328,7],[334,1,334,2],[346,4,346,6],[320,3,320,7],[2,0,2,5],[232,0,232,5],[250,0,250,5],[178,0,178,5],[179,0,179,5],[62,0,62,5],[120,0,120,5],[121,0,121,5],[59,0,59,1],[117,0,117,1],[175,0,175,1],[229,0,229,1],[59,4,59,6],[117,4,117,6],[175,4,175,6],[229,4,229,6],[314,1,314,5],[310,1,310,7],[312,1,312,5],[307,1,307,5],[304,1,304,5],[305,1,305,5],[306,1,306,5]]}
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E11)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:    December 31, 2021"}]
[]
["WASTEWATER OPERATING REVENUES AND EXPENSES"]
[null,"(a)",null,"(b)","(c) ","(d)"]
["Line  No.","Descriptions ","NARUC Waste-water Account Number","Dollar         Amount","Total                 Year-End Customers","Gallons of Effluent Collected Metered & Unmetered"]
[null,"OPERATING REVENUES ",null,null,null,"(in Thousands)",null,"         (Decrease)"]
[null,"REVENUE FROM WASTEWATER SALES:  ",400]
[1,"Flat Rate Revenues:"]
[{"$f":"1+A8","v":2},"             Residential Customers",521.20000000000005,0,0,0]
[{"$f":"1+A9","v":3},"             Commercial Customers",521.20000000000005,0,0,0]
[4,"             Industrial Customers",521.29999999999995,null,0,0]
[5,"             Public Authorities",521.4,0,null,0]
[6,"             Multiple Family Dwellings",521.5,0,0,0]
[7,"             Other **",521.6,0,0,0]
[8,"                  Total Flat Rate Revenues",null,{"$f":"SUM(D9:D14)","v":0},{"$f":"SUM(E9:E14)","v":0},{"$f":"SUM(F9:F14)","v":0}]
[9,"Measured Revenues:"]
[10,"              Residential Customers",522.1,0,null,0]
[11,"              Commercial Customers",522.20000000000005,0,0,0]
[12,"              Industrial Customers",522.29999999999995,0,0,0]
[13,"              Public Authorities",522.4,0,0,0]
[14,"              Multiple Family Dwellings",522.5,0,0,0]
[15,"                   Total Measured Revenues",null,{"$f":"SUM(D17:D21)","v":0},{"$f":"SUM(E17:E21)","v":0},{"$f":"SUM(F17:F21)","v":0}]
[16]
[{"$f":"1+A23","v":17},"Revenues from Other Systems **",524,0,0,0]
[18,"                    Total Sales of Wastewater         ",null,{"$f":"D24+D15+D22","v":0},{"$f":"E24+E15+E22","v":0},{"$f":"F24+F15+F22","v":0}]
[19]
[{"$f":"1+A26","v":20},"OTHER WASTEWATER REVENUES:"]
[21,"Guaranteed Revenues",530,0]
[22,"Other Wastewater Revenues **",536,0]
[23,"                      Total Other Wastewater Revenues",null,{"$f":"SUM(D28:D29)","v":0}]
[24]
[25,"           Total Operating Revenues     (to Page 5, Line 1)",400,{"$f":"+D25+D30","v":0}]
[26,{"$f":"+IF(D32>=200000,\"             ERROR - Total Operating Revenue exceeds $200,000, Please use 'Class B Annual Report.'\",\" \")","v":" "}]
[27]
[28,null,null,"This Year                  $","Last Year                 $","Increase or (Decrease)"]
[{"$f":"1+A35","v":29},"OPERATING EXPENSES",401]
[30,"Salaries & Wages - Employees",701,0,0,{"$f":"+D37-E37","v":0}]
[31,"Salaries & Wages - Officers, Directors & Major Stkhldrs",703,0,0,{"$f":"+D38-E38","v":0}]
[32,"Employee Pensions & Benefits",704,0,0,0]
[33,"Purchased Wastewater Treatment",710,0,0,0]
[34,"Sludge Removal Expense",711,0,0,{"$f":"+D41-E41","v":0}]
[{"$f":"1+A41","v":35},"Purchased Power",715,0,0,0]
[36,"Fuel for Power Production",716,0,0,0]
[37,"Chemicals",718,0,0,0]
[38,"Material and Supplies",720,0,0,0]
[39,"Contractual Services - Billing",730,0,0,0]
[40,"Contractual Services - Professional",731,0,0,0]
[41,"Contractual Services - Testing",735,0,0,0]
[42,"Contractual Services - Other **",736,0,0,0]
[43,"Rents",740,0,0,0]
[44,"Transportation Expense",750,0,0,0]
[45,"Insurance Expense",755,0,0,0]
[46,"Regulatory Commission Expense",765,0,0,0]
[47,"Bad Debt Expense",770,0,0,0]
[48,"Miscellaneous Expense **",775,0,0,0]
[49]
[50,"      Total Operating Expenses        (to Page 5, Line 3)",401,{"$f":"SUM(D37:D55)","v":0},{"$f":"SUM(E37:E55)","v":0},{"$f":"SUM(F37:F55)","v":0}]
[null,"**  If over $2,000, attach detailed supporting schedule."]
[]
["Docket No. 22-01003\nWastewater - Class C",null,"Page 4 of 11",null,"Revised January 2022"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E11)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:    December 31, 2021"}]
[]
["INCOME AND RETAINED EARNINGS STATEMENT"]
[null,"(a)",null,"(b)","(c) ","(d)"]
["Line  No.","Descriptions","NARUC Waste-water Account Number","This Year                       $","Last Year                                          $","Increase or (Decrease)"]
[null,"UTILITY OPERATING INCOME"]
[1,"Operating Revenues                 (from Page 4, Line 25)",400,{"$f":"+D32","v":0},0,{"$f":"+D67-E67","v":0}]
[{"$f":"1+A67","v":2}]
[{"$f":"1+A68","v":3},"Operating Expense                    (from Page 4, Line 50)",401,{"$f":"+D57","v":0},{"$f":"+E57","v":0},{"$f":"+D69-E69","v":0}]
["4a","Depreciation Expense               (to Page 6, Line 40, Col. (c))",403,0,0,{"$f":"+D70-E70","v":0}]
["4b","CIAC Amort. Expense - CR. *  (to Page 8, Line 26, Col. (c))",403,0,0,0]
[5,"Amortization Of Utility Plant Acquisition Adjustment",406,0,0,0]
[6,"Amortization Expense - Other **",407,0,0,0]
[7,"Taxes other than Income Taxes",408,0,0,0]
[8,"Federal Income Tax ",409,0,0,0]
[9,"Provision for Deferred Income Taxes - DR.",410,0,0,0]
[10,"Provision for Deferred Income Taxes - CR. *",411,0,0,0]
[11,"Investment Tax Credits - CR. *",412,0,0,0]
[12,"               Total Operating Expenses   ",null,{"$f":"SUM(D69:D78)","v":0},{"$f":"SUM(E69:E78)","v":0},{"$f":"SUM(F69:F78)","v":0}]
[13]
[{"$f":"1+A80","v":14},"Net Operating Income                       (Line 1 -  Line 12)",null,{"$f":"+D67-D79","v":0},{"$f":"+E67-E79","v":0},{"$f":"+F67-F79","v":0}]
[15]
[16,"OTHER INCOME and DEDUCTIONS"]
[17,"Interest & Dividend Income",419,0,0,{"$f":"+D84-E84","v":0},{"$f":"SUM(G81:G83)+G72+G79","v":0},{"$f":"SUM(H81:H83)+H72+H79","v":0}]
[18,"Allowance for Funds Used During Construction",420,0,0,0]
[19,"Non-Utility Income",421,0,0,0]
[20,"Less:  Miscellaneous Non-Utility Expense * and **",426,0,0,0]
[21,"Interest Expense *",427,0,0,0]
[22,"Taxes Applicable to Other Income & Deductions","408-412",0,0,0]
[23,"            Total Other Income & Deductions",null,{"$f":"SUM(D84:D89)","v":0},{"$f":"SUM(E84:E89)","v":0},{"$f":"SUM(F84:F89)","v":0}]
[24]
[25,"Net Income                       (Line 14 + Line 23)   (to Line 30)",null,{"$f":"+D81+D90","v":0},{"$f":"+E81+E90","v":0},{"$f":"+F81+F90","v":0}]
[26]
[27]
[28,"Retained Earnings   (Corporations ONLY)",215]
[29,"Retained Earnings   (beginning)      (from \"Last Year\" col.)",null,{"$f":"+E103","v":0},0,{"$f":"+D96-E96","v":0}]
[30,"Balance Transferred from Net Income           (from Line 25)",null,{"$f":"+D92","v":0},{"$f":"+E92","v":0},0]
[31,null,null," "," "," "]
[32,null,null," "," "," "]
[33,"Dividends Declared - Common Stock *",null,0,0,0]
[34,"Adjustments to Retained Earnings **",null,0,0,0]
[35]
[36,"Retained Earnings (ending)                  (to Page 7, Line 4)",215,{"$f":"SUM(D96:D101)","v":0},{"$f":"SUM(E96:E101)","v":0},{"$f":"SUM(F96:F101)","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"**  If over $2,000, attach detailed supporting schedule."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 22-01003\nWastewater - Class C",null,"Page 5 of 11",null,"Revised January 2022"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E11)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:    December 31, 2021"}]
[]
["BALANCE SHEET"]
["(Assets and Other Debits)"]
[null,"(a)",null,"(b)","(c)","(d)"]
["Line  No.","Descriptions","NARUC Waste-water Account Number","This Year                                     $","Last Year                              $","Increase or (Decrease)"]
[null,"UTILITY PLANT"]
[1,"Utility Plant                             (from Lines 38 & 42, Col. (b))",101,{"$f":"+D170","v":0},{"$f":"+D166","v":0},{"$f":"+D126-E126","v":0}]
[{"$f":"1+A126","v":2},"Less:  Accum. Dep.                 (from Lines 38 & 42, Col. (c))",108,{"$f":"-E170","v":0},{"$f":"-E166","v":0},{"$f":"+D127-E127","v":0}]
[{"$f":"1+A127","v":3},"          Net Utility Plant",null,{"$f":"SUM(D126:D127)","v":0},{"$f":"SUM(E126:E127)","v":0},{"$f":"SUM(F126:F127)","v":0}]
[4,"Property Held for Future Use",103,0,0,{"$f":"+D129-E129","v":0}]
[5,"Utility Plant Purchased or Sold",104,0,0,{"$f":"+D130-E130","v":0}]
[6,"Construction Work in Progress",105,0,0,{"$f":"+D131-E131","v":0}]
[7,"Utility Plant Acquisition Adjustments",114,0,0,{"$f":"+D132-E132","v":0}]
[8,"Less:  Amortization of Utility Plt. Acquisition Adjust.  *",115,0,0,{"$f":"+D133-E133","v":0}]
[9,"          Total Utility Plant",null,{"$f":"SUM(D128:D133)","v":0},{"$f":"SUM(E128:E133)","v":0},{"$f":"SUM(F128:F133)","v":0}]
[10]
[11,"OTHER PROPERTY AND INVESTMENTS"]
[12,"Non-Utility Property",121,0,0,{"$f":"+D137-E137","v":0}]
[13,"Less:  Accum. Depreciation & Amortization  *",122,0,0,{"$f":"+D138-E138","v":0}]
[14,"          Net Non-Utility Property",null,{"$f":"SUM(D137:D138)","v":0},{"$f":"SUM(E137:E138)","v":0},{"$f":"SUM(F137:F138)","v":0}]
[15,"Other Investments **",124,0,0,{"$f":"+D140-E140","v":0}]
[16,"          Total Other Property and Investments",null,{"$f":"SUM(D139:D140)","v":0},{"$f":"SUM(E139:E140)","v":0},{"$f":"SUM(F139:F140)","v":0}]
[17]
[18,"CURRENT AND ACCRUED ASSETS"]
[19,"Cash ",131,0,0,{"$f":"+D144-E144","v":0}]
[20,"Special Deposits",132,0,0,0]
[21,"Customer Accounts Receivable ",141,0,0,0]
[22,"Accum. Provision for Uncollectible Accounts - CR *",143,0,0,0]
[23,"Plant Material and Supplies",151,0,0,0]
[24,"Miscellaneous Current and Accrued Assets **",174,0,0,0]
[25,"          Total Current & Accrued Assets",null,{"$f":"SUM(D144:D149)","v":0},{"$f":"SUM(E144:E149)","v":0},{"$f":"SUM(F144:F149)","v":0}]
[26]
[27,"DEFERRED DEBITS"]
[28,"Miscellaneous Deferred Debits ",186,0,0,{"$f":"+D153-E153","v":0}]
[29,"           Total Deferred Debit",null,{"$f":"SUM(D153:D153)","v":0},{"$f":"SUM(E153:E153)","v":0},{"$f":"SUM(F153:F153)","v":0}]
[30]
[31,"Accumulated Deferred Income Taxes"]
[32,"Accumulated Deferred Income Taxes",190,0,0,{"$f":"+D157-E157","v":0}]
[33,"           Total Accumulated Deferred Incomes Taxes",null,{"$f":"SUM(D157:D157)","v":0},{"$f":"SUM(E157:E157)","v":0},{"$f":"SUM(F157:F157)","v":0}]
[34]
[35,"Total Assets & Other Debits                   (to Page 8, Line 8)",null,{"$f":"+D134+D141+D150+D154+D158","v":0},{"$f":"+E134+E141+E150+E154+E158","v":0},{"$f":"+F134+F141+F150+F154+F158","v":0}]
[]
[]
[]
[{"$f":"A160+1","v":36},"WASTEWATER UTILITY PLANT",null,"Total Utility Plant","Accum. Deprec.","Net"]
[37,"PLANT",null,"(Acct. 101)","(Acct. 108)","Utility Plant"]
[38,"Balance Beginning of Year",null,0,0,{"$f":"+D166-E166","v":0}]
[39,"Additions:                                            (Plant added during the year)",null,0,null,{"$f":"+D167","v":0}]
[40,"Current Year's Deprec. on Plant          (from Page 5, Line 4a)",null,null,{"$f":"+D70","v":0},{"$f":"-E168","v":0}]
[41,"Retirements / Deletions: - CR. *          (Plant removed during the year)",null,0,0,{"$f":"+D169+E169","v":0}]
[42,"Balance End of Current Year",null,{"$f":"+D166+D167+D169","v":0},{"$f":"+E166+E168-E169","v":0},{"$f":"+D170-E170","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"**  If over $2,000, attach detailed supporting schedule."]
[]
[]
[]
["Docket No. 22-01003\nWastewater - Class C",null,"Page 6 of 11",null,"Revised January 2022"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E11)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:    December 31, 2021"}]
[]
["BALANCE SHEET"]
["(Liabilities and Other Credits)"]
[null,"(a)",null,"(b)","(c)","(d)"]
["Line  No.","Descriptions","NARUC Waste-water Account Number","This Year                       $","Last Year                     $","Increase or (Decrease)"]
[null,"EQUITY CAPITAL"]
[1,"Common Stock Issued ",201,0,0,{"$f":"+D184-E184","v":0}]
[{"$f":"1+A184","v":2},"Preferred Stock Issued",204,0,0,{"$f":"+D185-E185","v":0}]
[{"$f":"1+A185","v":3},"Other Paid-In Capital ",211,0,0,{"$f":"+D186-E186","v":0}]
[4,"Retained Earnings   (Corporations ONLY)  (from Page 5, Line 36)",215,{"$f":"+D103","v":0},{"$f":"+E103","v":0},{"$f":"+F103","v":0}]
[5,"Proprietory Capital   (Proprietorships/Partnerships ONLY)",218,0,0,{"$f":"+D188-E188","v":0}]
[6,"        Total Equity Capital",null,{"$f":"SUM(D184:D188)","v":0},{"$f":"SUM(E184:E188)","v":0},{"$f":"SUM(F184:F188)","v":0}]
[7]
[8,"LONG TERM DEBT"]
[9,"Other Long-Term Debt ",224,0,0,{"$f":"+D192-E192","v":0}]
[10,"         Total Long-Term Debt ",null,{"$f":"SUM(D192:D192)","v":0},{"$f":"SUM(E192:E192)","v":0},{"$f":"SUM(F192:F192)","v":0}]
[11]
[12,"CURRENT AND ACCRUED LIABILITIES"]
[13,"Accounts Payable ",231,0,0,{"$f":"+D196-E196","v":0}]
[14,"Notes Payable  ",232,0,0,0]
[15,"Customer Deposits ",235,0,0,0]
[16,"Accrued Taxes",236,0,0,0]
[17,"Accrued Interest ",237,0,0,0]
[18,"Miscellaneous Current and Accrued Liabilities **",241,0,0,0]
[19,"        Total Current & Accrued Liabilities",null,{"$f":"SUM(D196:D201)","v":0},{"$f":"SUM(E196:E201)","v":0},{"$f":"SUM(F196:F201)","v":0}]
[20]
[21,"DEFERRED CREDITS"]
[22," Advances for Construction ",252,0,0,{"$f":"+D205-E205","v":0}]
[23,"Other Deferred Credits ",253,0,0,{"$f":"+D206-E206","v":0}]
[24,"Accumulated Deferred Investment Tax Credits",255,0,0,{"$f":"+D207-E207","v":0}]
[25,"         Total Deferred Credits",null,{"$f":"SUM(D205:D207)","v":0},{"$f":"SUM(E205:E207)","v":0},{"$f":"SUM(F205:F207)","v":0}]
[26]
[27,"OPERATING RESERVES"]
[28,"Miscellaneous Operating Reserves **",265,0,0,{"$f":"+D211-E211","v":0}]
[29,"       Total Operating Reserves",null,{"$f":"SUM(D211:D211)","v":0},{"$f":"SUM(E211:E211)","v":0},{"$f":"SUM(F211:F211)","v":0}]
[30]
[31,"CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[32,"Contributions in Aid of Construction ",271,{"$f":"D285","v":0},{"$f":"D281","v":0},{"$f":"+D215-E215","v":0}]
[33,"Less:  Amortization of Contributions in Aid of Constr.  ",272,{"$f":"-E285","v":0},{"$f":"-E281","v":0},{"$f":"+D216-E216","v":0}]
[34,"        Net Contributions in Aid of Construction",null,{"$f":"SUM(D215:D216)","v":0},{"$f":"SUM(E215:E216)","v":0},{"$f":"SUM(F215:F216)","v":0}]
[35]
[36,"ACCUM. DEF. INCOME TAXES"]
[37,"Accum. Def. Income Taxes - Accelerated Depreciation",281,0,0,{"$f":"+D220-E220","v":0}]
[38,"Accum. Def. Income Taxes - Liberalized Depreciation",282,0,0,{"$f":"+D221-E221","v":0}]
[39,"Accum. Def. Income Taxes - Other",283,0,0,{"$f":"+D222-E222","v":0}]
[40,"       Total Accum. Deferred Income Taxes",null,{"$f":"SUM(D220:D222)","v":0},{"$f":"SUM(E220:E222)","v":0},{"$f":"SUM(F220:F222)","v":0}]
[41]
[42,"Total Liabilities and Other Credits       (to Page 8,  Line 9)",null,{"$f":"+D189+D193+D202+D208+D212+D217+D223","v":0},{"$f":"+E189+E193+E202+E208+E212+E217+E223","v":0},{"$f":"+F189+F193+F202+F208+F212+F217+F223","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"**  If over $2,000, attach detailed supporting schedule."]
[]
[]
["Docket No. 22-01003\nWastewater - Class C",null,"Page 7 of 11",null,"Revised January 2022"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E11)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:    December 31, 2021"}]
[]
["OTHER INFORMATION"]
[]
[]
["Line\nNo.","DEPRECIATION RATES BY MAJOR PLANT CATEGORY"]
[null,"(a)",null,"(b)","(c)","(d)"]
[null,null,null,"Total Utility Plant","Annual Depr.  Exp.","Annual Depr. %"]
[1,"Intangible plant                                    (Plant Accts. 351 - 353)",null,0,0,{"$f":"IF(+E239=0,0,E239/D239)","v":0}]
[{"$f":"A239+1","v":2},"Structures & Improvements                 (Plant Accts. 354 - 355)",null,0,0,0]
[3,"Collection System                                (Plant Accts. 360 - 365)",null,0,0,0]
[4,"Receiving Wells                                   (Plant Acct. 370)",null,0,0,0]
[5,"Treatment & Disposal                          (Plant Accts. 380 - 389)",null,0,0,0]
[6,"General plant                                        (Plant Accts. 390 - 398)",null,0,0,0]
[7,"           Totals  ",null,{"$f":"SUM(D239:D244)","v":0},{"$f":"SUM(E239:E244)","v":0}]
[null,"           Error [Difference from Page 6, Line 1, Col. (b)]",null,{"$f":"D126-D245","v":0}]
[null,"           Error [Difference from Page 5, Line 4a, Col. (b)]",null,null,{"$f":"D70-E245","v":0}]
[]
[]
[]
["VERIFICATION THAT ASSETS EQUALS LIABILITIES ON BALANCE SHEET"]
[null,"(a)",null,"(b)","(c)","(d)"]
[null,null,null,"This Year                       $","Last Year                   $","Increase or (Decrease)"]
[{"$f":"A245+1","v":8},"BALANCE SHEET - Total Assets                      (from Page 6, Line 35)",null,{"$f":"+D160","v":0},{"$f":"+E160","v":0},{"$f":"+D254-E254","v":0}]
[{"$f":"A254+1","v":9},"BALANCE SHEET - Total Liabilities                (from Page 7, Line 42)",null,{"$f":"D225","v":0},{"$f":"E225","v":0},{"$f":"+D255-E255","v":0}]
[{"$f":"A255+1","v":10},"   Difference -  MUST BE EQUAL TO ZERO!",null,{"$f":"IF(ROUND(D254,0)-ROUND(D255,0)=0,\"0\",\"ERROR\")","v":"0"},{"$f":"IF(ROUND(E254,0)-ROUND(E255,0)=0,\"0\",\"ERROR\")","v":"0"},{"$f":"IF(ROUND(F254,0)-ROUND(F255,0)=0,\"0\",\"ERROR\")","v":"0"}]
[]
[]
[]
[]
["SIMPLIFIED, UNAUDITED AND UNADJUSTED RATE OF RETURN CALCULATION"]
[null,"(a)",null,"(b)","(c)","(d)"]
[null,null,null,"This Year                       $","Last Year                   $","Increase or (Decrease)"]
[{"$f":"1+A256","v":11},"Net Operating Income                                             (from Page 5, Line 14)  ",null,{"$f":"+D81","v":0},{"$f":"+E81","v":0},{"$f":"+D264-E264","v":0}]
[{"$f":"1+A264","v":12},"Rate Base ***",null,{"$f":"+D274","v":0},{"$f":"+E274","v":0},{"$f":"+D265-E265","v":0}]
[{"$f":"1+A265","v":13},"Rate of Return Calculation                    (Line 11 / Line 12)",null,{"$f":"IF(+D264=0,0,D264/D265)","v":0},{"$f":"IF(+E264=0,0,E264/E265)","v":0}]
[{"$f":"1+A266","v":14}]
[15,"*** Rate Base composed of the following:"]
[16,"     Total Utility Plant  (Page 6, Line 9)",null,{"$f":"+D134","v":0},{"$f":"+E134","v":0}]
[17,"     Less:  Net CIAC   (Page 7, Line 34)",null,{"$f":"-D217","v":0},{"$f":"-E217","v":0}]
[18,"     Add:  Plant Material and Supplies  (Page 6, Line 23)",null,{"$f":"+D148","v":0},{"$f":"+E148","v":0}]
[19,"     Add:  Accum. Def. Inc. Taxes - Acct. 190   (Page 6, Line 32)",null,{"$f":"+D157","v":0},{"$f":"+E157","v":0}]
[20,"     Less:  Accum. Def. Inc. Taxes - Accts. 281/282/283  (Page 7, Line 40)",null,{"$f":"-D223","v":0},{"$f":"-E223","v":0}]
[21,"                        TOTAL",null,{"$f":"SUM(D269:D273)","v":0},{"$f":"SUM(E269:E273)","v":0}]
[]
[]
[]
[null,"(a)",null,"(b)","(c)","(d)"]
[{"$f":"A274+1","v":22},"WASTEWATER UTILITY CIAC",null,"Total Utility CIAC","Accum. Amort.","Net"]
[{"$f":"1+A279","v":23},"CONTRIBUTIONS IN AID OF CONSTRUCTION",null,"(Acct. 271)","(Acct. 272)","Utility CIAC"]
[24,"Balance Beginning of Year",null,0,0,{"$f":"+D281-E281","v":0}]
[25,"Additions:                                            (CIAC added during the year)",null,0,null,{"$f":"+D282","v":0}]
[26,"Current Yr's Amortization on CIAC    (from Page 5, Line 4b)",null,null,{"$f":"-D71","v":0},{"$f":"-E283","v":0}]
[27,"Retirements / Deletions: - CR. *         (CIAC removed during the year)",null,0,0,{"$f":"+D284-E284","v":0}]
[28,"Balance End of Current Year",null,{"$f":"+D281+D282+D284","v":0},{"$f":"+E281+E283+E284","v":0},{"$f":"+D285-E285","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[]
[]
[]
[]
["Docket No. 22-01003\nWastewater - Class C",null,"Page 8 of 11",null,"Revised January 2022"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!E11)","v":"Annual Report of:    "},null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:    December 31, 2021"}]
[]
[]
[]
["OATH"]
[]
[]
[null,"I,",null,null,null,"on behalf of",", President and"]
[null,null,"[name of signatory]"]
[null,null,null,null,null,"declare under","of"]
[null,"[regulated entity]"]
[null,"penalty of perjury under the laws of the State of Nevada that I have carefully examined the foregoing "]
[]
[null,"information provided to the Public Utilities Commission of Nevada, and declare it to be a complete and "]
[]
[null,"correct statement to the best of my knowledge, information and belief; and that I have the authority to make "]
[]
[null,"these representations and to bind the regulated entity on whose behalf I am providing this information."]
[]
[null,"I further declare that the foregoing information has been prepared by me or under my direction from the"]
[]
[null,"original books, papers and records of the regulated entity and that any accounts and/or figures provided"]
[]
[null,"embrace all the relevant financial operations of the regulated entity during the period of time for which the "]
[]
[null,"information is provided."]
[]
[]
[null,null,"Printed Name:"]
[]
[null,null,"Title:"]
[]
[null,null,"Date:"]
[]
[]
[]
[]
[null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 22-01003\nWastewater - Class C",null,"Page 9 of 11",null,"Revised January 2022"]

{"sheet":"SurchargeInformation","index":4,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,0,68,6],[3,0,3,6],[4,0,4,6],[28,0,28,6],[29,0,29,6],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3]]}
[]
[{"$f":"CONCATENATE(\"Annual Report of:  \",'Cover Pages 1-2'!E11)","v":"Annual Report of:  "},null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:  December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:  December 31, 2021"}]
[]
["System Improvement Surcharge"]
["Schedule 1"]
[]
[]
["MONTH","SURCHARGE AMOUNT","X","NO. OF CUSTOMERS","=","TOTAL BILLED","TOTAL COLLECTED"]
[]
["JANUARY",null,null,null,null,{"$f":"B10*D10","v":0}]
["FEBRUARY",null,null,null,null,{"$f":"B11*D11","v":0}," "]
["MARCH",null,null,null,null,0," "]
["APRIL",null,null,null,null,0," "]
["MAY",null,null,null,null,0," "]
["JUNE",null,null,null,null,0," "]
["JULY",null,null,null,null,0," "]
["AUGUST",null,null,null,null,0," "]
["SEPTEMBER",null,null,null,null,0," "]
["OCTOBER",null,null,null,null,0," "]
["NOVEMBER",null,null,null,null,0," "]
["DECEMBER",null,null,null,null,0," "]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G10:G21)","v":0}]
[]
[]
[]
[{"$f":"CONCATENATE(\"Annual Report of:  \",'Cover Pages 1-2'!E11)","v":"Annual Report of:  "},null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:  December 31, \",'Cover Pages 1-2'!H19)","v":"For the Period Ending:  December 31, 2021"}]
[]
["System Improvement Surcharge"]
["Schedule 2"]
[]
["SUMMARY OF SURCHARGE COLLECTION AND EXPENDITURES"]
[]
[null,null,null,"Account Balance from Previous Year",null,null,0]
["DEPOSITS"]
[]
["DATE","TOTAL COLLECTED (FROM SCH 1)",null,"TOTAL DEPOSITED",null,"DIFFERENCE                   (EXPLANATION REQUIRED)"]
[]
["JANUARY",{"$f":"G10","v":0},null," "]
["FEBRUARY",{"$f":"G11","v":" "},null," "]
["MARCH"," ",null," "]
["APRIL"," ",null," "]
["MAY"," ",null," "]
["JUNE"," ",null," "]
["JULY"," ",null," "]
["AUGUST"," ",null," "]
["SEPTEMBER"," ",null," "]
["OCTOBER"," ",null," "]
["NOVEMBER"," ",null," "]
["DECEMBER"," ",null," "]
[]
[null,"Total for Year",null,{"$f":"SUM(D39:D50)","v":0},null,null,{"$f":"D52","v":0}]
[]
[null,null,null,"Interest Earned This Year",null,null,0]
[]
["DISBURSEMENTS - Attach additional sheets if necessary."]
[]
["DATE","DESCRIPTION",null,null,null,"TOTAL DISBURSEMENT"]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,"Total for Year",null,{"$f":"SUM(F59:F62)","v":0},{"$f":"-F63","v":0}]
[null,null,null,"Account Service Charge",null,null,0]
[]
[null,null,null,"End of Year Account Balance",null,null,{"$f":"G34+G52+G54+G63+G64","v":0}]
[]
["INCLUDE BANK STATEMENT ENDING DECEMBER 31st - Please redact (black out) any"]
["confidential information such as bank account number, Social Security Number or Employer Identification Number in the bank statement, or file the information confidentially pursuant to the Commission's procedures in NAC 703.5274."]

{"sheet":"Data","index":5,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"YEAR:"]
[null,"Select Year"]
[null,2004]
[null,2005]
[null,2006]
[null,2007]
[null,2008]
[null,2009]
[null,2010]
[null,2011]
[null,2012]
[null,2013]
[null,2014]
[null,2015]
[null,2016]
[null,2017]
[null,2018]
[null,2019]
[null,2020]
[null,2021]
[null,2022]
[null,2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]